Elements and Performance Criteria
- Use safe work practices
- Workspace, furniture and equipment are adjusted to suit the ergonomic requirements of the user
- Work organisation meets organisational and statutory requirements for computer operation
- Energy and resource conservation techniques are used to minimise wastage in accordance with organisational and statutory requirements
- Develop a linked database solution
- Task is analysed and specifications for databases are determined
- Organisational and task requirements in relation to data entry, storage, output, reporting and presentation requirements are identified
- Databases are designed and constructed to meet the requirements of the given situation
- Field attributes are set according to data type and databases are linked by a common field in accordance with software procedures
- Database design utilises software functions and formulae to meet identified requirements
- Develop database record forms and reports
- Data entry forms are designed and created to meet specified requirements for entering and displaying information
- Data table and form layout enable efficient data input and display
- Field attributes are set according to data type and formulae / calculated field incorporated to meet task specifications
- Report formats are designed and c reated according to specified criteria using conditional operators as required
- Database reports are formatted in accordance with organisational style and presentation requirements
- Queries and formulae are tested to confirm output meets task requirements
- Automate and standardise database operation
- Tasks are evaluated to identify those where automation would increase efficiency
- Macros are created, used and edited to fulfil the requirements of the task and automate database operation
- Templates are developed, edited and used to ensure consistency of design and layout for forms and reports in accordance with organisational requirements
- Use databases
- Data is entered, checked and amended in accordance with organisational and task requirements
- Data is imported / exported between compatible databases and host documents adjusted in accordance with software and system procedures
- Manuals, user documentation and on-line help are used to overcome problems with spreadsheet design and production
- Database reports and/or forms are previewed, adjusted and printed in accordance with organisational and task requirements
- Database is named and stored, in accordance with organisational requirements and the application exited without data loss/damage